When a prompted report is saved, the last-selected prompt values are also saved. In some cases, one or more of those values might not be valid. For example, you select Tracker Shoes as the value for a Product prompt and save the report. Later, the Tracker Shoes product is removed from the data source. The next time someone opens the report, Tracker Shoes is still available as a prompt value, although it returns no results.
In some cases, the last-saved prompt value might be a value that a user should not be permitted to see. For example, an identity-driven filter has been applied to the Country data item so that UserA can see Germany and Canada and UserB can see U.S.A. and Mexico. The report also has a prompted filter for Country. If UserB views results for Mexico and saves the report, then UserA will see Mexico as a prompt value the next time UserA accesses the report. If UserA selects Mexico, he sees no results because the identity-driven filter is enforced.
As a workaround for version 3.1, before exiting the report, you can reset report prompts to the default values and save the report.
If you are using versions 4.2 through 4.31_M1, you must reset the prompts to the default values, view the report, and then save.
Beginning with SAS Web Report Studio 4.31_M2, you can set a system-wide property that does one of the following, depending on the specified value.
To set this property, make the following changes to the SAS Web Report Studio properties in SAS® Management Console.
wrs.save.promptValues.option
KeepCustomerPromptValues
Note: Typically, you would only use this property if you wanted to change the behavior from one of the other options back to the default.
ResetPromptValues
Note: Do not use ResetPromptValues
if your report includes identity-driven filters. These two options are not compatible. If they are used together, you see an error that the value of a fixed prompt cannot be cleared. Currently, there is no workaround that enables you to use ResetPromptValues
with an identity-driven filter.
ClearPromptValues
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Web Report Studio | Microsoft Windows 2000 Advanced Server | 3.1 | 9.1 TS1M3 SP4 | ||
Microsoft Windows 2000 Datacenter Server | 3.1 | 9.1 TS1M3 SP4 | ||||
Microsoft Windows 2000 Server | 3.1 | 9.1 TS1M3 SP4 | ||||
Microsoft Windows 2000 Professional | 3.1 | 9.1 TS1M3 SP4 | ||||
Microsoft Windows NT Workstation | 3.1 | 9.1 TS1M3 SP4 | ||||
Microsoft Windows Server 2003 Datacenter Edition | 3.1 | 4.31_M2 | 9.1 TS1M3 SP4 | 9.3 TS1M2 | ||
Microsoft Windows Server 2003 Enterprise Edition | 3.1 | 4.31_M2 | 9.1 TS1M3 SP4 | 9.3 TS1M2 | ||
Microsoft Windows Server 2003 Standard Edition | 3.1 | 4.31_M2 | 9.1 TS1M3 SP4 | 9.3 TS1M2 | ||
Microsoft Windows XP Professional | 3.1 | 4.31_M2 | 9.1 TS1M3 SP4 | 9.3 TS1M2 | ||
Windows Vista | 3.1 | 4.31_M2 | 9.1 TS1M3 SP4 | 9.3 TS1M2 | ||
Windows Vista for x64 | 3.1 | 4.31_M2 | 9.1 TS1M3 SP4 | 9.3 TS1M2 | ||
64-bit Enabled AIX | 3.1 | 4.31_M2 | 9.1 TS1M3 SP4 | 9.3 TS1M2 | ||
64-bit Enabled Solaris | 3.1 | 4.31_M2 | 9.1 TS1M3 SP4 | 9.3 TS1M2 | ||
HP-UX IPF | 3.1 | 4.31_M2 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Type: | Usage Note |
Priority: | high |
Topic: | Query and Reporting ==> Interactive Querying |
Date Modified: | 2012-08-28 13:34:18 |
Date Created: | 2010-08-17 10:05:45 |